Tabela LContractCareTaker

Definicja tabeli LContractCareTaker

Name

LContractCareTaker

Code

LContractCareTaker

Comment

PL: Polaczenie opiekuna z umowa – przyporzadkowanie opiekuna dla umowy
EN: Link between curator and contract – assignement curator for contract


Lista kolumn tabeli LContractCareTaker

Name

Code

LContractCareTakerID

LContractCareTakerID

ContractID

ContractID

CareTakerID

CareTakerID

CareTakerTypeID

CareTakerTypeID

StartDT

StartDT

StopDT

StopDT


Kolumna LContractCareTakerID tabeli LContractCareTaker

Definicja kolumny LContractCareTakerID tabeli LContractCareTaker

Name

LContractCareTakerID

Code

LContractCareTakerID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractID tabeli LContractCareTaker

Definicja kolumny ContractID tabeli LContractCareTaker

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CareTakerID tabeli LContractCareTaker

Definicja kolumny CareTakerID tabeli LContractCareTaker

Name

CareTakerID

Code

CareTakerID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CareTakerTypeID tabeli LContractCareTaker

Definicja kolumny CareTakerTypeID tabeli LContractCareTaker

Name

CareTakerTypeID

Code

CareTakerTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli LContractCareTaker

Definicja kolumny StartDT tabeli LContractCareTaker

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LContractCareTaker

Definicja kolumny StopDT tabeli LContractCareTaker

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli LContractCareTaker

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LContractCareTaker

Definicja klucza Identifier_1 tabeli LContractCareTaker

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment